-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `type` varchar(255) DEFAULT NULL COMMENT '操作类型(''add''-增加；''del''-删除；''upd''-更新；''login''-登陆''；''logout''-登出''；''addorupd''-新增或修改；''qry''-查询)',
  `name` varchar(255) DEFAULT NULL COMMENT '操作备注',
  `login_name` varchar(255) DEFAULT NULL COMMENT '登陆名',
  `real_name` varchar(255) DEFAULT NULL COMMENT '真实姓名',
  `src_ip` varchar(255) DEFAULT NULL COMMENT '操作IP',
  `params` text COMMENT '操作参数',
  `date_add` datetime DEFAULT NULL COMMENT '添加时间',
  PRIMARY KEY (`id`),
  KEY `fk_user_name` (`real_name`) USING BTREE,
  KEY `fk_type` (`type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=132866 DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `pid` int(11) DEFAULT NULL COMMENT '父节点ID',
  `menu_name` varchar(255) DEFAULT NULL COMMENT '菜单名称',
  `path` varchar(255) DEFAULT NULL COMMENT '资源地址',
  `domain` varchar(255) DEFAULT NULL COMMENT '域名',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序序号',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` int(3) DEFAULT NULL COMMENT '状态',
  `note` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, -1, '运营管理系统', '', '', '', 1, '2018-12-12 17:02:21', '2018-12-11 11:23:07', 1, '');
INSERT INTO `sys_menu` VALUES (2, -1, '系统管理', '', '', 'fa fa-cogs', 5, '2018-12-29 13:44:27', '2018-12-11 11:23:42', 1, '');
INSERT INTO `sys_menu` VALUES (3, 154, '系统用户管理', '/sysuser/page', '', NULL, 1, '2018-12-12 13:54:43', '2018-12-11 11:24:21', 1, '');
INSERT INTO `sys_menu` VALUES (64, 154, '系统菜单管理', '/sysmenu/page', '', NULL, 3, '2018-12-12 13:54:55', '2018-12-11 11:24:21', 1, '');
INSERT INTO `sys_menu` VALUES (65, 154, '系统角色管理', '/sysrole/page', '', NULL, 2, '2018-12-12 13:54:49', '2018-12-11 11:24:21', 1, '');
INSERT INTO `sys_menu` VALUES (66, 154, '系统日志管理', '/systemLog/page', '', NULL, 4, '2018-12-12 13:55:01', '2018-12-11 11:24:21', 1, '');
INSERT INTO `sys_menu` VALUES (77, 1, '排行榜管理', '/rank/page', '', 'fa fa-reorder', 7, '2018-12-12 13:34:35', '2018-12-11 14:26:43', 1, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `pid` int(11) DEFAULT NULL COMMENT '父节点ID',
  `role_name` varchar(32) DEFAULT NULL COMMENT '角色名称',
  `menu_ids` text COMMENT '菜单项ID',
  `level` int(2) DEFAULT NULL COMMENT '分级',
  `sort` int(11) DEFAULT NULL COMMENT '排序序号',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` int(2) DEFAULT NULL COMMENT '状态',
  `note` text COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, -1, '超级管理员', '88,89,110,111,112,113,114,115,116,90,117,91,118,92,119,93,94,95,96,97,98,99,120,121,1,122,123,2,124,3,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,154,156,157,162,163,164,165,64,65,66,68,69,70,71,72,76,77,78,79,100,101,102,103,104,105,106,107,80,108,81,109,82,83,85,86,87', 0, 1, '2019-01-07 16:03:06', '2018-12-11 14:49:33', 1, '');
INSERT INTO `sys_role` VALUES (73, 1, '运营管理员', '88,89,110,154,111,112,113,114,115,116,90,117,91,118,92,119,93,94,95,96,97,98,99,120,121,1,122,123,2,124,3,125,126,127,128,129,66,68,69,130,131,132,133,134,135,136,137,138,139,70,71,72,76,77,78,79,140,141,142,100,101,102,103,104,105,106,107,80,108,81,109,82,83,85,86,87', 1, 4, '2019-01-09 11:12:42', '2018-12-13 12:40:16', 1, '');
INSERT INTO `sys_role` VALUES (74, 1, '技术管理员', '88,89,110,154,111,112,113,114,115,116,90,117,91,118,92,119,93,94,95,96,97,98,99,120,121,1,122,123,2,124,3,125,126,127,128,129,66,68,69,130,131,132,133,134,135,136,137,138,139,70,71,72,76,77,78,79,140,141,142,100,101,102,103,104,105,106,107,80,108,81,109,82,83,85,86,87', 1, 5, '2019-01-09 11:12:54', '2018-12-13 12:40:48', 1, '');
INSERT INTO `sys_role` VALUES (75, 73, '运营小组', '88,89,110,111,112,113,114,115,116,90,117,91,118,92,119,93,94,95,96,97,98,99,120,121,1,122,123,124,125,126,127,128,129,68,69,130,131,132,133,134,135,136,137,138,139,70,71,72,76,77,78,79,140,141,142,100,101,102,103,104,105,106,107,80,108,81,109,82,83,85,86,87', 2, 2, '2018-12-29 16:22:52', '2018-12-13 12:41:06', 1, '');
INSERT INTO `sys_role` VALUES (76, 74, '技术小组', '88,89,110,111,112,113,114,115,116,90,117,91,118,92,119,93,94,95,96,97,98,99,120,121,1,122,123,124,125,126,127,128,129,68,69,130,131,132,133,134,135,136,137,138,139,70,71,72,76,77,78,79,140,141,142,100,101,102,103,104,105,106,107,80,108,81,109,82,83,85,86,87', 2, 2, '2018-12-29 16:22:30', '2018-12-13 12:41:14', 1, '');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
  `role_ids` varchar(255) DEFAULT NULL COMMENT '角色项ID',
  `real_name` varchar(255) DEFAULT NULL COMMENT '真实姓名',
  `login_name` varchar(255) DEFAULT NULL COMMENT '登陆名',
  `encrypted_password` varchar(255) DEFAULT NULL COMMENT '加密密钥',
  `salt` varchar(255) DEFAULT NULL COMMENT '加密随机字符串',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `telephone` varchar(255) DEFAULT NULL COMMENT '移动电话',
  `department` varchar(255) DEFAULT NULL COMMENT '部门',
  `register_date` datetime DEFAULT NULL COMMENT '注册时间',
  `level` int(2) DEFAULT NULL COMMENT '分级',
  `roles` varchar(255) DEFAULT NULL COMMENT 'x',
  `state` int(2) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='系统用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, '1', '超级管理员', 'cms_admin', '7a31f31c955b0453555e2e287587d9740ea00b86', 'f86d6b4b7c419d86', NULL, NULL, NULL, '2017-11-24 16:11:15', 0, 'god', 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------
-- Table structure for tbl_rank
-- ----------------------------
DROP TABLE IF EXISTS `tbl_rank`;
CREATE TABLE `tbl_rank` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自动递增',
  `col_name` varchar(255) DEFAULT NULL COMMENT '名称',
  `col_poster` varchar(255) DEFAULT NULL COMMENT '封面图',
  `col_sort` int(11) DEFAULT NULL COMMENT '排序',
  `enabled_pro` varchar(255) DEFAULT NULL COMMENT '生效产品：1-今日影视；2-韩剧大全；303-芝麻影视；304-影视大全',
  `plat_form` varchar(255) DEFAULT NULL COMMENT '生效平台',
  `col_state` int(11) DEFAULT NULL COMMENT '状态(0:未启用；1:启用；',
  `col_sub_name` varchar(255) DEFAULT NULL COMMENT '副标题',
  `col_video_type` int(11) DEFAULT NULL COMMENT '视频类型',
  `col_rank_num` varchar(255) DEFAULT NULL COMMENT '英文标识',
  `outside_num` int(11) DEFAULT NULL COMMENT '排行榜展示数',
  `inside_num` int(11) DEFAULT NULL COMMENT '包含内容数',
  `robot_flag` int(3) DEFAULT NULL COMMENT '数据源标识(0-CMS手动配置；1-代理层自动化获取)',
  `rank_status` int(3) DEFAULT '-1' COMMENT '操作审核状态(0-初审；1-复审；2-已发布)',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `fk_tbl_kk_rank_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COMMENT='排行榜';

-- ----------------------------
-- Records of tbl_rank
-- ----------------------------
BEGIN;
INSERT INTO `tbl_rank` VALUES (4, '电视剧', '', 4, '1,2,303,304,305', 'iphone,ipad,aphone,apad,atv', 1, '11', 1, 'm_rank_tv', 5, 20, 1, 2);
INSERT INTO `tbl_rank` VALUES (7, '电影', '', 5, '1,2,303,304,305', 'iphone,ipad,aphone,apad,atv', 1, '', 2, 'm_rank_movie', 5, 25, 1, 1);
INSERT INTO `tbl_rank` VALUES (10, '动漫', '', 8, '1,303,304', 'iphone,ipad,aphone,apad,atv', 1, '', 3, 'm_rank_cartoon', 5, 20, 0, -1);
INSERT INTO `tbl_rank` VALUES (37, '综艺', '', 6, '1,2,303,304,399,305,306,307', 'iphone,ipad,aphone,apad,atv', 1, '综艺副标题', 4, 'm_rank_zongyi', 6, 15, 0, -1);
INSERT INTO `tbl_rank` VALUES (38, '儿童', '', 10, '1,2,303,304,399,305,306,307', 'iphone,ipad,aphone,apad,atv', -1, '儿童副标题', 6, 'm_rank_kid', 4, 15, 0, -1);
INSERT INTO `tbl_rank` VALUES (54, '动漫', '', 7, '1,303,304', 'iphone,ipad,aphone,apad,atv', 1, '自动化数据', 3, 'dongman_andr', 5, 20, 1, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;